Release 10.1A: OpenEdge Data Management:
SQL Reference


ABS

Computes the absolute value of expression.

Syntax

ABS ( expression ) 

Example

This example illustrates the ABS function:

SELECT ABS (MONTHS_BETWEEN (SYSDATE, order_date)) 
    FROM orders
    WHERE  ABS (MONTHS_BETWEEN (SYSDATE, order_date)) > 3 ; 

Notes

Compatibility

ODBC compatible


Copyright © 2005 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095